﻿CREATE TABLE [dbo].[OrderOperationRecord] (
    [RecordID]      BIGINT         IDENTITY (1, 1) NOT NULL,
    [RecordTime]    DATETIME       NOT NULL,
    [OrderID]       VARCHAR (32)   NOT NULL,
    [OperationType] TINYINT        NOT NULL,
    [UserID]        BIGINT         NULL,
    [ManageID]      INT            NULL,
    [Description]   NVARCHAR (300) NULL,
    [Opreator]      NVARCHAR (20)  NOT NULL,
    [ShowUserMsg]   NVARCHAR (300) NULL,
    CONSTRAINT [PK_ORDEROPERATIONRECORD] PRIMARY KEY CLUSTERED ([RecordID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'展示给用户的信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'ShowUserMsg';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'Opreator';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作描述', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'Description';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理员标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'ManageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作类型 1:创建订单；2：支付；3：审核1通过；4：审核2通过；5：审核失败；6：关闭订单；7：发货；8：确认收货；9：被拆分', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'OperationType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'OrderID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'记录时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'RecordTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'记录标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord', @level2type = N'COLUMN', @level2name = N'RecordID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单操作记录', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderOperationRecord';

